Prestashop Advance Importing Pro

import from any CSV/Excel file

• created: 07/14/2015
• latest update: 08/01/2016
• by: buy-addons

Step 1: Upload File

• File(Excel/CSV): required - choose file excel(csv,xls,xlsx)
• Images(Zip file): (optional) - choose file images(zip)
• New Items: (optional) - Choose action when get new product from CSV/Excel File ( Insert to NEW product or ignore)
• Existing Items: (optional) - Choose action when check EXIST product from CSV/Excel File ( UPDATE product or ignore)
• Identify Existing Product by Matching Field: (optional) - Field for indentity exist product for update/add
• Items to import: (optional) - the number of ROWS in  CSV/Excel file will be imported

Step 2: Mapping

• Product Name: Name of Product
• Reference code
• Product Tags: In CSV/Excel file, Tags is a COLUMN, multiple tags seperate to comma, ex: tag1,tag 2
• Product ID: ID of Product
• Status (Y/N): Status of Product. In Csv/Excel file, this column shoud be Y or N (not case sensitive)
• ISO Language: example: us for English, es for Spanish (not case sensitive)
• Currency ISO Code:  USD for Dollars, EUR for Euros, etc. (not case sensitive)
• Name of default Category: Name of MAIN Category in your prestashop store
• Name of Associated categories: You can match multiple FIELDS on CSV/Excel to this FIELD because a product can have belong to many categories, but ONLY have DEFAULT category
• Supplier: Name of Supplier
• Manufacturer: Name of Manufacturer
• Product Addition Image: You can match multiple FIELDS on CSV/Excel to this FIELD
• Product Main Image: ONLY match a field to this infomation

1. Qestion 1

• Q: I can import 10,000 rows from our CSV/Excel?
• A: Yes, our module use Ajax for importing, so customer can import MASS file, import thousands Rows with 1-click at the same time

2. Question 2

• Q: How to import main category to website?
• A: You can mapping category name in your file to Name of default Category in mapping step, our module will auto get category's name like this columns, then import product and assign to this category.

3. Question 3

• Q: How to import multiple categores?
• A: In prestashop system, a product ONLY can assigned to MAIN category, but can assigned to multiple other categories. so you can imported multiple categories by: mapping all category columns in your site to Name of Associated categories  in select box

4. Question 4

• Q: How to import Cover photo( Main image)?
• A: In prestashop system, a product ONLY have Cover photo. you can mapping column image name in your file to Product Main Image in select box, our module supported both of images which uploaded from zip file (in step 1) and external URLs as http://domain.com/sample.jpg

5. Question 5

• Q: How to import multiple images?
• A: You can mapping all column which have image name to Product Addition Image in Select box.

6. Question 6

• Q: I can import features from this module?
• A: Yes, our module will auto get all features on your site, then fill to select box. so you can mapping all feature name column to them

7. Question 7

• Q: How to import status?
• A: In your file, you need have a column with Y or N. Y=Yes, N=No. then mapping this column to Status (Y/N) in select box in step 2.

8.Question 8

• Q: How to import languages?
• A: In your file, you need have a column which contain ISO language as en,fr,ru.. then mapping this columns to ISO Language in select box

9. Question 9

• Q: I can import price with my currency?
• A: Yes, you need have a column which contain Currency ISO Code as USD,EUR.. then mapping this columns to Currency ISO Code in select box

10. Question 10

• Q: How to import product tags?
• A: you need created a column Tag which have multiple tag seperate with commas, then mapping column to Product Tags in select box

11. Question 11

• Q: I click import, but module is loading and No result
• A: Some website have wrong in config domain, so www.domain.com and domain.com is 2 differents. so please try to add www or remove www in your URL, then try to import it again.
• Example try to 2 URLs:
  • http://www.domain.com/admin
  • http://domain.com/admin

12. Question 12

• Q: We can import caption for product images
• A: Yes, you can enter caption in columns of excel like this Caption | image_or_UrlToImage, then mapping there columns to image like Question 4,5
  

13. Question 13

• Q: We can import from remove URL
• A: Yes, you can import from URL as http:///domain.com/example.csv

14. Question 14

• Q: We can import combination, attributes, variants, features?
• A: Yes

15. Question 15

• Q: We can import warehouse?
• A: Yes, you can import Stock, Price, Label... for all warehouses in your store. our module will AUTOMATIC get all warehouse and fill to Select option while mapping step (step 2)

16. Question 16

• Q: We can set AUTO import from remote URL?
• A: Yes, in step 2, you can MAPPING FIELDS before click Set Auto Work like this

• then in step 3 set time for automatic work

17. Question 17

• Q: How to import combination infomation?
• A:
  • Step 1: choose Identify Existing Product by Matching Field:
  • 
  • Step 2: In CSV/Excel File, Create columns for Attributes, Each Attribute is ONE columns in CSV/Excel file. Example: columns: Color, Size
  • 
  • Step 3: match columns to Attributes
  • 
  • After Mapping, we can see it like below
  • 
  • Step 4 (optional): match some combination like: Image, Reference code, Quantity like below
  • 
  • Click Importing
  •  

18. Question 18

• Q: What is workflow for importing Combination?
• Y: Read get a ROW from CSV/Excel file, import module will work like:
  • Step 1: Check Product exist Or not exist based Identify Existing Product by Matching Field
    • If product EXIST, next to Step 2
    • If product is NOT EXIST, create New product then next to Step 2
  • Step 2: get All attributes which matched, Check Attributes EXIST or NOT EXIST from your website
    • If All Attributes EXIST, next to Step 3
    • If any Attributes is NOT EXIST, create New Attribute for this. example from our module, Attribute No Color, Size S will be created in this step. Next to Step 3
  • Step 3: check Combination for All attributes
    • If Combination EXIST: Update all infomation (SKU, quantity, Image) for this Combination
    • f Combination is NOT EXIST: Create New Combination which included all attributes, then Update all infomation (SKU, quantity, Image) for this Combination

19. Question 19

• Q: How to importing multi languages?
• A:
  • Step 1:
    • 
  • Step 2:
    • 

20. Question 20

• Q: How to importing multi settings?
• A:
  • Step 1:
    • 
  • Step 2:
    •